package com.itheima.dao;

import com.itheima.pojo.Order;
import com.itheima.pojo.OrderInfoVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Date;
import java.util.List;
import java.util.Map;

public interface OrderMapper {

    void add(Order order);

    Order findByOrder(Order queryParam);

    @Select("select m.name,m.phoneNumber telephone ,o.orderType, o.orderDate, o.setmeal_id setmealId ,s.name setmeal from t_order o,t_member m,t_setmeal s where o.setmeal_id=s.id and o.member_id=m.id and o.id=#{id}")
    OrderInfoVo findById(String id);

    List<Map> chartReportInterface();
}
